/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 50712
 Source Host           : localhost:3306
 Source Schema         : manager

 Target Server Type    : MySQL
 Target Server Version : 50712
 File Encoding         : 65001

 Date: 21/04/2019 22:12:39
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for action
-- ----------------------------
DROP TABLE IF EXISTS `action`;
CREATE TABLE `action` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action_name` varchar(64) NOT NULL DEFAULT '',
  `url` varchar(255) NOT NULL DEFAULT '',
  `module_id` int(11) NOT NULL DEFAULT '0',
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `action_code` varchar(255) NOT NULL DEFAULT '' COMMENT '权限',
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=53 DEFAULT CHARSET=utf8 COMMENT='—(方法/权限)菜单';

-- ----------------------------
-- Records of action
-- ----------------------------
BEGIN;
INSERT INTO `action` VALUES (1, '首页管理 ', '/admin/welcome', 0, 0, 'admin:home', '2019-02-12 09:33:02');
INSERT INTO `action` VALUES (2, '用户管理', '/admin/user', 0, 0, 'user:list', '2019-02-12 17:18:47');
INSERT INTO `action` VALUES (3, '权限管理', '/admin/action/list', 0, 0, 'action:list', '2019-02-12 17:18:50');
INSERT INTO `action` VALUES (5, '课堂中心', '/admin/course', 0, 0, 'course:list', '2019-02-12 17:18:53');
INSERT INTO `action` VALUES (6, '影视管理', '/admin/video', 0, 0, 'video:list', '2019-02-12 17:18:56');
INSERT INTO `action` VALUES (7, '系统设置', '/admin/settings', 0, 0, 'admin:settings', '2019-02-12 17:18:59');
INSERT INTO `action` VALUES (8, '欢迎光临', '/admin/welcome', 0, 1, 'admin:welcome', '2019-02-12 11:45:06');
INSERT INTO `action` VALUES (9, '用户列表', '/admin/user/list', 0, 2, 'user:list', '2019-02-12 17:19:02');
INSERT INTO `action` VALUES (10, '菜单管理', '/admin/action/list', 0, 3, 'action:list', '2019-02-12 17:19:04');
INSERT INTO `action` VALUES (11, '角色管理', '/admin/role/list', 0, 3, 'role:list', '2019-02-12 17:19:06');
INSERT INTO `action` VALUES (4, '分类管理', '/admin/category/', 0, 0, 'category:list', '2019-02-11 22:39:15');
INSERT INTO `action` VALUES (12, '分类列表', '/admin/category/list', 0, 4, 'category:list', '2019-02-12 22:47:05');
INSERT INTO `action` VALUES (13, '新增课程', '/admin/course/add', 0, 15, 'course:add', '2019-03-03 07:35:55');
INSERT INTO `action` VALUES (15, '课程列表', '/admin/course/list', 0, 5, 'course:list', '2019-03-14 04:14:00');
INSERT INTO `action` VALUES (14, '编辑课程', '/admin/course/edit', 0, 15, 'course:edit', '2019-03-14 04:03:54');
INSERT INTO `action` VALUES (16, '电视剧列表', '/admin/video/list', 0, 6, 'video:list', '2019-04-01 02:03:36');
INSERT INTO `action` VALUES (17, '电影列表', '/admin/movie/list', 0, 6, 'movie:list', '2019-04-02 13:11:45');
INSERT INTO `action` VALUES (18, '添加分类', '/admin/category/add', 0, 12, 'category:add', '2019-04-14 04:04:28');
INSERT INTO `action` VALUES (19, '分类编辑', '/admin/category/edit', 0, 12, 'category:edit', '2019-04-14 07:20:25');
INSERT INTO `action` VALUES (20, '分类删除', '/admin/category/delete', 0, 12, 'category:delete', '2019-04-14 07:21:11');
INSERT INTO `action` VALUES (21, '添加菜单', '/admin/action/add', 0, 10, 'action:add', '2019-04-14 15:45:52');
INSERT INTO `action` VALUES (22, '编辑菜单', '/admin/action/edit', 0, 10, 'action:edit', '2019-04-14 07:47:02');
INSERT INTO `action` VALUES (23, '删除菜单', '/admin/action/delete', 0, 10, 'action:delete', '2019-04-14 07:47:50');
INSERT INTO `action` VALUES (24, '删除课堂', '/admin/course/delete', 0, 15, 'course:delete', '2019-04-14 07:50:12');
INSERT INTO `action` VALUES (25, '课程章节', '/admin/course/section', 0, 15, 'course:section', '2019-04-14 07:50:52');
INSERT INTO `action` VALUES (26, '添加用户', '/admin/user/add', 0, 9, 'user:add', '2019-04-14 09:37:33');
INSERT INTO `action` VALUES (27, '编辑用户', '/admin/user/edit', 0, 9, 'user:edit', '2019-04-14 09:37:57');
INSERT INTO `action` VALUES (28, '删除用户', '/admin/user/delete', 0, 9, 'user:delete', '2019-04-14 09:38:32');
INSERT INTO `action` VALUES (29, '添加章节', '/admin/course/section/add', 0, 25, 'section:add', '2019-04-14 09:44:53');
INSERT INTO `action` VALUES (30, '编辑章节', '/admin/course/section/edit', 0, 25, 'section:edit', '2019-04-14 09:45:34');
INSERT INTO `action` VALUES (31, '章节删除', '/admin/course/section/delete', 0, 25, 'section:delete', '2019-04-14 09:45:58');
INSERT INTO `action` VALUES (32, '添加', '/admin/video/add', 0, 16, 'video:add', '2019-04-14 09:51:03');
INSERT INTO `action` VALUES (33, '编辑', '/admin/video/edit', 0, 16, 'video:edit', '2019-04-14 09:51:50');
INSERT INTO `action` VALUES (34, '删除', '/admin/video/delete', 0, 16, 'video:delete', '2019-04-14 09:52:25');
INSERT INTO `action` VALUES (35, '电视剧部', '/admin/video/sections', 0, 16, 'video:part', '2019-04-14 09:53:05');
INSERT INTO `action` VALUES (36, '添加部', '/admin/video/section/add', 0, 35, 'part:add', '2019-04-14 09:53:49');
INSERT INTO `action` VALUES (37, '编辑部', '/admin/video/section/edit', 0, 35, 'part:edit', '2019-04-14 09:55:00');
INSERT INTO `action` VALUES (38, '删除部', '/admin/video/section/delete', 0, 35, 'part:delete', '2019-04-14 09:55:44');
INSERT INTO `action` VALUES (39, '添加电影', '/admin/movie/add', 0, 17, 'movie:add', '2019-04-14 09:58:24');
INSERT INTO `action` VALUES (40, '编辑电影', '/admin/movie/edit', 0, 17, 'movie:edit', '2019-04-14 09:58:50');
INSERT INTO `action` VALUES (41, '删除电影', '/admin/movie/delete', 0, 17, 'movie:delete', '2019-04-14 09:59:26');
INSERT INTO `action` VALUES (42, '角色添加', '/admin/role/add', 0, 11, 'role:add', '2019-04-15 14:27:34');
INSERT INTO `action` VALUES (43, '编辑角色', '/admin/role/edit', 0, 11, 'role:edit', '2019-04-15 14:31:17');
INSERT INTO `action` VALUES (44, '删除角色', '/admin/role/delete', 0, 11, 'role:delete', '2019-04-15 14:31:55');
INSERT INTO `action` VALUES (45, '分配权限', '/admin/perms/list', 0, 11, 'perms:list', '2019-04-15 14:42:03');
INSERT INTO `action` VALUES (46, '管理员列表', '/admin/manager/list', 0, 3, 'manager:list', '2019-04-15 15:02:50');
INSERT INTO `action` VALUES (47, '添加管理员', '/admin/manager/add', 0, 46, 'manager:add', '2019-04-20 06:24:34');
INSERT INTO `action` VALUES (48, '编辑管理员', '/admin/manager/edit', 0, 46, 'manager:edit', '2019-04-20 06:25:30');
INSERT INTO `action` VALUES (49, '删除管理员', '/admin/manager/delete', 0, 46, 'manager:delete', '2019-04-20 06:26:08');
INSERT INTO `action` VALUES (51, '网站配置', '/admin/settings', 0, 7, 'admin:settings', '2019-04-21 13:23:07');
INSERT INTO `action` VALUES (50, 'Banner设置', '/admin/banner/list', 0, 7, 'banner:list', '2019-04-21 13:24:31');
COMMIT;

-- ----------------------------
-- Table structure for banner
-- ----------------------------
DROP TABLE IF EXISTS `banner`;
CREATE TABLE `banner` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '名称',
  `position` tinyint(2) NOT NULL DEFAULT '1' COMMENT '1 首页轮播图(通用) ，2 课程首页轮播，3影视轮播',
  `status` tinyint(2) NOT NULL DEFAULT '1',
  `url` varchar(255) NOT NULL DEFAULT '',
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `c_name` varchar(64) NOT NULL DEFAULT '' COMMENT '分类名称',
  `type` tinyint(2) NOT NULL DEFAULT '1' COMMENT '1 是课程分类，2影视分类',
  `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT '父级id',
  `create_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `status` tinyint(2) DEFAULT '1' COMMENT '1 正常',
  `icon` varchar(255) NOT NULL DEFAULT '' COMMENT '分类图片',
  `local_sort` smallint(6) NOT NULL DEFAULT '1' COMMENT '排序',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of category
-- ----------------------------
BEGIN;
INSERT INTO `category` VALUES (1, '美剧', 2, 0, '2019-03-27 21:57:22', 1, '/category/2019/1553695040536.png', 2);
INSERT INTO `category` VALUES (2, '欧美', 2, 0, '2019-03-24 18:06:53', 1, '/category/2019/1551598174799.png', 3);
INSERT INTO `category` VALUES (3, '纪录片', 2, 0, '2019-03-24 18:09:28', 1, '', 2);
INSERT INTO `category` VALUES (4, '科幻', 2, 1, '2019-03-24 10:10:25', 1, '', 4);
INSERT INTO `category` VALUES (5, '事实', 2, 3, '2019-03-24 10:10:52', 1, '', 4);
INSERT INTO `category` VALUES (6, '爱情', 2, 1, '2019-03-24 10:11:14', 1, '', 45);
INSERT INTO `category` VALUES (7, '计算机', 1, 0, '2019-03-24 18:14:16', 1, '', 102);
INSERT INTO `category` VALUES (8, 'java', 1, 7, '2019-04-02 19:51:47', 1, '', 444);
INSERT INTO `category` VALUES (9, 'c/c++', 1, 7, '2019-04-01 09:42:43', 1, '', 542);
COMMIT;

-- ----------------------------
-- Table structure for product
-- ----------------------------
DROP TABLE IF EXISTS `product`;
CREATE TABLE `product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '课程/电影标题',
  `cate_id` smallint(6) NOT NULL DEFAULT '0' COMMENT '分类id',
  `description` varchar(255) NOT NULL DEFAULT '' COMMENT '秒杀',
  `content` varchar(12000) NOT NULL DEFAULT '' COMMENT '内容 - 图文',
  `author_id` smallint(6) NOT NULL DEFAULT '0' COMMENT '讲师/发布人',
  `create_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `thumb` varchar(255) NOT NULL DEFAULT '' COMMENT '手机端缩略图',
  `picture` varchar(255) NOT NULL DEFAULT '' COMMENT 'PC端图片',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 正常 ， 0 下架 ， -1 删除',
  `price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '价格',
  `cost` tinyint(2) NOT NULL DEFAULT '0' COMMENT '1 收费 ， 0 免费',
  `scope` tinyint(2) NOT NULL DEFAULT '3' COMMENT '1 一集，2 多集 ， 3 多部',
  `type` tinyint(2) NOT NULL COMMENT '1 课程 ， 2 连续剧 ， 3 电影',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='产品表 电影/课程';

-- ----------------------------
-- Records of product
-- ----------------------------
BEGIN;
INSERT INTO `product` VALUES (1, 'Java学习(入门到实战)', 8, 'Java入门，基础知识编', '<p>Java入门课程</p>', 1, '2019-04-02 11:54:41', '/art/2019/4/1554206071820.png', '/art/2019/4/1554206067975.png', 1, 0.00, 0, 3, 0);
INSERT INTO `product` VALUES (2, 'Java 面向对象程序设计', 8, '面向对象程序设计编', '<p>Java面向对象程序设计</p>', 1, '2019-04-02 11:55:26', '/art/2019/4/1554206118241.png', '/art/2019/4/1554206114641.png', 0, 0.00, 0, 3, 0);
INSERT INTO `product` VALUES (3, 'java 网络编程', 8, 'socket,多线程', '<p>Java高级部分</p>', 1, '2019-04-02 12:22:58', '/art/2019/4/1554207769514.png', '/art/2019/4/1554207766446.png', 1, 0.00, 0, 3, 0);
INSERT INTO `product` VALUES (4, '真爱无价', 6, '最经典的美剧', '<p>爱情片</p>', 1, '2019-04-02 12:34:06', '/art/2019/4/1554208439118.png', '/art/2019/4/1554208435820.png', 1, 0.00, 0, 1, 0);
INSERT INTO `product` VALUES (11, '速度与激情', 4, '1-2', '<p>1-2</p>', 1, '2019-04-05 18:02:59', '/art/2019/4/1554350129551.png', '/art/2019/4/1554350124544.png', 1, 0.00, 0, 2, 3);
INSERT INTO `product` VALUES (12, '老友记', 4, '1-7部都有', '<p>老友记好老的片子</p>', 1, '2019-04-05 10:22:05', '/art/2019/4/1554459689449.png', '/art/2019/4/1554459676880.png', 1, 0.00, 0, 3, 2);
INSERT INTO `product` VALUES (13, '西游记英文版', 4, '就一部', '<p>一共28集</p>', 1, '2019-04-05 10:26:27', '/art/2019/4/1554459971551.png', '/art/2019/4/1554459967903.png', 1, 0.00, 0, 2, 2);
COMMIT;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(64) DEFAULT NULL COMMENT '角色名称',
  `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '1 正常',
  `description` varchar(255) NOT NULL DEFAULT '' COMMENT '描述',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO `role` VALUES (1, '超级管理员', 1, '啥都能做');
INSERT INTO `role` VALUES (2, '课堂管理员', 1, '只负责课堂中心的管理');
INSERT INTO `role` VALUES (3, '影视管理员', 1, '影视发布与管理');
INSERT INTO `role` VALUES (4, 'A级管理员', 1, '分类，课堂，影视都能管');
COMMIT;

-- ----------------------------
-- Table structure for role_action
-- ----------------------------
DROP TABLE IF EXISTS `role_action`;
CREATE TABLE `role_action` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action_id` int(11) NOT NULL DEFAULT '0',
  `role_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of role_action
-- ----------------------------
BEGIN;
INSERT INTO `role_action` VALUES (46, 39, 1);
INSERT INTO `role_action` VALUES (45, 17, 1);
INSERT INTO `role_action` VALUES (44, 38, 1);
INSERT INTO `role_action` VALUES (43, 37, 1);
INSERT INTO `role_action` VALUES (42, 36, 1);
INSERT INTO `role_action` VALUES (41, 35, 1);
INSERT INTO `role_action` VALUES (40, 34, 1);
INSERT INTO `role_action` VALUES (39, 33, 1);
INSERT INTO `role_action` VALUES (38, 32, 1);
INSERT INTO `role_action` VALUES (37, 16, 1);
INSERT INTO `role_action` VALUES (36, 6, 1);
INSERT INTO `role_action` VALUES (35, 31, 1);
INSERT INTO `role_action` VALUES (34, 30, 1);
INSERT INTO `role_action` VALUES (33, 29, 1);
INSERT INTO `role_action` VALUES (32, 25, 1);
INSERT INTO `role_action` VALUES (31, 24, 1);
INSERT INTO `role_action` VALUES (30, 14, 1);
INSERT INTO `role_action` VALUES (29, 13, 1);
INSERT INTO `role_action` VALUES (28, 15, 1);
INSERT INTO `role_action` VALUES (27, 5, 1);
INSERT INTO `role_action` VALUES (26, 20, 1);
INSERT INTO `role_action` VALUES (25, 19, 1);
INSERT INTO `role_action` VALUES (24, 18, 1);
INSERT INTO `role_action` VALUES (23, 12, 1);
INSERT INTO `role_action` VALUES (22, 4, 1);
INSERT INTO `role_action` VALUES (21, 49, 1);
INSERT INTO `role_action` VALUES (20, 48, 1);
INSERT INTO `role_action` VALUES (19, 47, 1);
INSERT INTO `role_action` VALUES (18, 46, 1);
INSERT INTO `role_action` VALUES (17, 45, 1);
INSERT INTO `role_action` VALUES (16, 44, 1);
INSERT INTO `role_action` VALUES (15, 43, 1);
INSERT INTO `role_action` VALUES (14, 42, 1);
INSERT INTO `role_action` VALUES (13, 11, 1);
INSERT INTO `role_action` VALUES (12, 23, 1);
INSERT INTO `role_action` VALUES (11, 22, 1);
INSERT INTO `role_action` VALUES (10, 21, 1);
INSERT INTO `role_action` VALUES (9, 10, 1);
INSERT INTO `role_action` VALUES (8, 3, 1);
INSERT INTO `role_action` VALUES (7, 28, 1);
INSERT INTO `role_action` VALUES (6, 27, 1);
INSERT INTO `role_action` VALUES (5, 26, 1);
INSERT INTO `role_action` VALUES (4, 9, 1);
INSERT INTO `role_action` VALUES (3, 2, 1);
INSERT INTO `role_action` VALUES (2, 8, 1);
INSERT INTO `role_action` VALUES (1, 1, 1);
INSERT INTO `role_action` VALUES (51, 51, 1);
INSERT INTO `role_action` VALUES (50, 50, 1);
INSERT INTO `role_action` VALUES (47, 40, 1);
INSERT INTO `role_action` VALUES (48, 41, 1);
INSERT INTO `role_action` VALUES (49, 7, 1);
COMMIT;

-- ----------------------------
-- Table structure for role_user
-- ----------------------------
DROP TABLE IF EXISTS `role_user`;
CREATE TABLE `role_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `role_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='—角色-用户表';

-- ----------------------------
-- Records of role_user
-- ----------------------------
BEGIN;
INSERT INTO `role_user` VALUES (1, 1, 1);
INSERT INTO `role_user` VALUES (4, 4, 4);
COMMIT;

-- ----------------------------
-- Table structure for section
-- ----------------------------
DROP TABLE IF EXISTS `section`;
CREATE TABLE `section` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
  `product_id` int(11) NOT NULL DEFAULT '0' COMMENT '产品id',
  `description` varchar(255) NOT NULL DEFAULT '' COMMENT '描述',
  `lv` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 章 ， 2 节',
  `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT '上级id （节有章的id）',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 正常 ， 0 禁用 ， -1 删除',
  `create_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `vedio_url` varchar(255) NOT NULL DEFAULT '' COMMENT '视频地址',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=utf8 COMMENT='章节/视频';

-- ----------------------------
-- Records of section
-- ----------------------------
BEGIN;
INSERT INTO `section` VALUES (1, 'Java语言介绍', 1, 'Java是一个面向对象程序设计语言', 1, 0, 0, '2019-04-02 11:56:29', '');
INSERT INTO `section` VALUES (2, '第一节', 1, '', 2, 1, 1, '2019-04-02 11:56:29', '/art/2019/4/1554206186551.mp4');
INSERT INTO `section` VALUES (3, '第二节', 1, '', 2, 1, 1, '2019-04-02 11:57:26', '/art/2019/4/1554206233102.mp4');
INSERT INTO `section` VALUES (4, 'jvm 介绍', 1, 'jvm 工作原理，垃圾回收机制', 1, 0, 0, '2019-04-02 11:58:36', '');
INSERT INTO `section` VALUES (5, '第一节', 1, '', 2, 4, 1, '2019-04-02 20:02:25', '/art/2019/4/1554206310945.mp4');
INSERT INTO `section` VALUES (6, '面向对象程序设计思路', 2, '面向对象程序设计思路', 1, 0, 0, '2019-04-02 12:01:08', '');
INSERT INTO `section` VALUES (7, '第一节，程序设计思路', 2, '', 2, 6, 1, '2019-04-02 20:02:31', '/art/2019/4/1554206440228.mp4');
INSERT INTO `section` VALUES (8, '第二节，程序优化思路', 2, '', 2, 6, 1, '2019-04-02 20:02:36', '/art/2019/4/1554206465786.mp4');
INSERT INTO `section` VALUES (9, '项目实战', 2, '面向对象程序设计之项目实战', 1, 0, 0, '2019-04-02 12:13:43', '');
INSERT INTO `section` VALUES (10, '第一节，他他他他', 2, '', 2, 9, 1, '2019-04-02 20:21:25', '/art/2019/4/1554207215404.mp4');
INSERT INTO `section` VALUES (11, '课后练习', 2, '练习', 1, 0, 0, '2019-04-02 12:15:14', '');
INSERT INTO `section` VALUES (12, '第一节，编程题', 2, '', 2, 11, 1, '2019-04-02 20:21:33', '/art/2019/4/1554207307497.mp4');
INSERT INTO `section` VALUES (19, '第二节，server', 3, '', 2, 17, 1, '2019-04-02 12:32:46', '/art/2019/4/1554208330808.mp4');
INSERT INTO `section` VALUES (18, '第一节，soket', 3, '', 2, 17, 1, '2019-04-02 12:32:46', '/art/2019/4/1554208317468.mp4');
INSERT INTO `section` VALUES (17, '网络编程', 3, 'socket 编程', 1, 0, 0, '2019-04-02 12:32:30', '');
INSERT INTO `section` VALUES (20, '第三节，client', 3, '', 2, 17, 1, '2019-04-02 12:32:46', '/art/2019/4/1554208345485.mp4');
INSERT INTO `section` VALUES (21, '真爱', 4, '真爱无价', 1, 0, 1, '2019-04-02 12:34:56', '');
INSERT INTO `section` VALUES (22, '真爱', 4, '', 2, 21, 1, '2019-04-02 12:34:56', '/art/2019/4/1554208463217.mp4');
INSERT INTO `section` VALUES (35, '3', 12, '', 2, 29, 1, '2019-04-06 09:09:28', '/art/2019/4/1554541758513.mp4');
INSERT INTO `section` VALUES (29, '第一部', 12, '1-3集', 1, 0, 1, '2019-04-06 17:12:37', '');
INSERT INTO `section` VALUES (28, '第二集', 11, '', 2, -1, 1, '2019-04-06 07:57:10', '/art/2019/4/1554537396168.mp4');
INSERT INTO `section` VALUES (27, '第一集', 11, '', 2, -1, 1, '2019-04-06 07:56:58', '/art/2019/4/1554537386805.mp4');
INSERT INTO `section` VALUES (34, '2', 12, '', 2, 29, 1, '2019-04-06 09:09:28', '/art/2019/4/1554541751611.mp4');
INSERT INTO `section` VALUES (33, '1', 12, '', 2, 29, 1, '2019-04-06 09:09:28', '/art/2019/4/1554541744720.mp4');
INSERT INTO `section` VALUES (36, '第二部', 12, '4-5集', 1, 0, 1, '2019-04-06 17:21:59', '');
INSERT INTO `section` VALUES (37, '4', 12, '', 2, 36, 1, '2019-04-06 09:17:04', '/art/2019/4/1554542205495.mp4');
INSERT INTO `section` VALUES (38, '5', 12, '', 2, 36, 1, '2019-04-06 09:17:04', '/art/2019/4/1554542221722.mp4');
INSERT INTO `section` VALUES (39, '第一集', 13, '', 2, -1, 1, '2019-04-06 09:27:05', '/art/2019/4/1554542769046.mp4');
INSERT INTO `section` VALUES (40, '第二季，大闹天宫', 13, '', 2, -1, 1, '2019-04-06 09:27:05', '/art/2019/4/1554542790021.mp4');
INSERT INTO `section` VALUES (41, '第三季，去西天取经', 13, '', 2, -1, 1, '2019-04-06 09:27:05', '/art/2019/4/1554542812531.mp4');
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account` varchar(64) NOT NULL DEFAULT '' COMMENT '账号',
  `password` varchar(64) NOT NULL DEFAULT '' COMMENT '密码',
  `realname` varchar(64) NOT NULL DEFAULT '' COMMENT '真实姓名',
  `type` tinyint(2) NOT NULL DEFAULT '1' COMMENT '1 是管理员，2 是普通用户',
  `phone` varchar(13) NOT NULL DEFAULT '',
  `create_time` datetime DEFAULT NULL,
  `avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '头像',
  `status` tinyint(2) DEFAULT '1' COMMENT '1 是正常 ，2是禁用',
  `gender` tinyint(2) NOT NULL DEFAULT '0' COMMENT '0未知，1 男',
  `unionId` varbinary(64) NOT NULL DEFAULT '' COMMENT '微信登录',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, 'admin', '123456', 'abduahad', 1, '18902123716', '2019-02-08 14:21:53', '', 1, 1, '');
INSERT INTO `user` VALUES (4, 'test', '1234567', '测试者', 1, '18902129928', '2019-04-20 17:14:16', '', 1, 1, '');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
